Spread Windows Forms 10.0 Product Documentation
GetValidConditionalFormat(Int32,Int32,IPrePaintConditionalFormattingRule[],IPrePaintTextConditionalFormattingRule[]) Method
Example 


Row index
Column index
Prepaint conditional format rules
Prepaint text conditional format rules
Gets the valid conditional format.
Syntax
'Declaration
 
Public Sub GetValidConditionalFormat( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByRef prePaintCFRules As IPrePaintConditionalFormattingRule(), _
   ByRef prePaintTextCFRules As IPrePaintTextConditionalFormattingRule() _
) 
'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim prePaintCFRules As IPrePaintConditionalFormattingRule()
Dim prePaintTextCFRules As IPrePaintTextConditionalFormattingRule()
 
instance.GetValidConditionalFormat(row, column, prePaintCFRules, prePaintTextCFRules)
public void GetValidConditionalFormat( 
   int row,
   int column,
   out IPrePaintConditionalFormattingRule[] prePaintCFRules,
   out IPrePaintTextConditionalFormattingRule[] prePaintTextCFRules
)

Parameters

row
Row index
column
Column index
prePaintCFRules
Prepaint conditional format rules
prePaintTextCFRules
Prepaint text conditional format rules
Example
This example uses the GetValidConditionalFormat method.
private void Form1_Load(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
            fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
            fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
            fpSpread1.Sheets[0].Cells[0, 2].Value = 1;            
        }

        private void button1_Click(object sender, EventArgs e)
        {
FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 3, false);
unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo;
//unary.Value = 3;
unary.BackColor = Color.Red;
unary.FontStyle = new FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold);

fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, unary);
fpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, unary);

FarPoint.Win.Spread.IPrePaintConditionalFormattingRule[] prePaintRule;
FarPoint.Win.Spread.IPrePaintTextConditionalFormattingRule[] prePaintTextRule;
fpSpread1.ActiveSheet.GetValidConditionalFormat(0, 0, out prePaintRule, out prePaintTextRule);

FarPoint.Win.Spread.PrePaintResult pp = prePaintRule[0].Execute(0, 0, fpSpread1.ActiveSheet.Cells[0, 0].Value);
FarPoint.Win.Spread.StyleInfo source = new FarPoint.Win.Spread.StyleInfo();
fpSpread1.ActiveSheet.Cells[1, 1].Value = 3;
FarPoint.Win.Spread.PrePaintResult pp1 = prePaintRule[0].Execute(1, 1, fpSpread1.ActiveSheet.Cells[1, 1].Value);        
        }
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets(0).Cells(0, 0).Value = 3
        FpSpread1.Sheets(0).Cells(1, 0).Value = 2
        FpSpread1.Sheets(0).Cells(1, 1).Value = 10
        FpSpread1.Sheets(0).Cells(0, 2).Value = 1
    End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Unary comparison CF
Dim unary As New FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 3, False)
unary.[Operator] = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo
'unary.Value = 3;
unary.BackColor = Color.Red
unary.FontStyle = New FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold)

FpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, unary)
FpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, unary)

Dim prePaintRule As FarPoint.Win.Spread.IPrePaintConditionalFormattingRule()
Dim prePaintTextRule As FarPoint.Win.Spread.IPrePaintTextConditionalFormattingRule()
FpSpread1.ActiveSheet.GetValidConditionalFormat(0, 0, prePaintRule, prePaintTextRule)

Dim pp As FarPoint.Win.Spread.PrePaintResult = prePaintRule(0).Execute(0, 0, FpSpread1.ActiveSheet.Cells(0, 0).Value)
Dim source As New FarPoint.Win.Spread.StyleInfo()
FpSpread1.ActiveSheet.Cells(1, 1).Value = 3
Dim pp1 As FarPoint.Win.Spread.PrePaintResult = prePaintRule(0).Execute(1, 1, FpSpread1.ActiveSheet.Cells(1, 1).Value)
    End Sub
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SheetView Class
SheetView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.